# ************************************************************
# https://anotherssisframework.codeplex.com

#Copyright (c) 2014, Allen J. Zyck <sql.architect@outlook.com>

# Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
# documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights 
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons
# to whom the Software is furnished to do so, subject to the following conditions:

# The above copyright notice and this permission notice shall be included in all copies or substantial portions of the 
# Software.

# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, 
# INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE 
# AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, 
# DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 
# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

# ************************************************************
#
# Powershell script to set environment variable for SSIS Framework
#
# Al Zyck 2014
#
# Before running, ensure Set-ExecutionPolicy <value> has been run on server
# Should work with Powershell v1 and later
#

$inputInstance = Read-Host "Enter the server\instance name that hosts the SSIS DW Config Database "
$inputDB = Read-Host "Enter the Configuration DB name of the SSIS DW Config Database "

If ($inputInstance -eq "" -OR $inputDB -eq "")
{
	"Invalid entry"
}
Else
{
	[Environment]::SetEnvironmentVariable("DWConfigInstance", $inputInstance, "Machine")
	"DWConfigInstance environment variable set to: " + $inputInstance

	[Environment]::SetEnvironmentVariable("DWConfigDB", $inputDB, "Machine")
	"DWConfigDB environment variable set to: " + $inputDB
}

